row lock

Changing page lock into row lock to shrink range of data locked;

改变页锁为行锁，缩小锁定数据的范围；

互联网摘选

This is because the new X row lock and the IS table lock are not compatible.

这是因为新的X行锁定和IS表锁定是不兼容的。

互联网摘选

These next key locks are only obtained when the key INSERT finds that a scanner with a Repeatable Read ( RR) isolation level has a row lock on the next-higher key in the index.

这些next key锁只有在key INSERT发现带有Repeatable Read（RR）隔离级别的扫描器在索引中的next-higher键上有一个行锁时才能获得。

互联网摘选

The database manager determines which locks to escalate by looking through the lock list for the application and finding the table with the most row locks.

数据库管理器通过查看应用程序的锁列表并查找行锁最多的表，来决定对哪些锁进行升级。

互联网摘选

The hang is caused by an exclusive row lock on table EMPLOYEE.

挂起是由表EMPLOYEE上一个独占式的行锁导致的。

互联网摘选

If this row lock is protecting an uncommitted UPDATE or DELETE action, DB2 cannot process or ignore the row until the outcome of the change is known.

如果这个行锁在保护一个未提交的UPDATE或DELETE动作，那么DB2不能处理或忽略该行，直到变化的结果已知。

互联网摘选

The row is formatted in the target page and an X ( exclusive) row lock is obtained on it.

在目标页中对该行进行格式化，并获得该行上的一个X（exclusive，独占的）行锁。

互联网摘选

If a transaction obtains a row lock for a row, the transaction also acquires a table lock for the corresponding table.

如果一个事务获得了一行的行锁，那么这个事务同时获得了相关的表的锁。

互联网摘选

If a concurrently connected application happens to be holding an incompatible row lock, the import utility pauses until that application commits or rolls back its transaction.

如果一个并发连接的应用程序碰巧持有不兼容的行锁，那么import工具就会暂停，直到该应用程序提交或回滚其事务。

互联网摘选

Information about the lock that was requested by the waiting application, such as row or table lock, shared or exclusive lock, table name, and so on.

等待应用程序请求的锁信息，如行或表锁、共享或独占锁、表名等等。

互联网摘选

These locks could be table level, row level, or lock on index, and so on.

这些锁可以是表级锁、行级锁、索引锁等等。

互联网摘选

When DB2 performs an index or table scan, DB2 will block on a row lock when it comes across an uncommitted row which another transaction has exclusively ( X) locked.

DB2在执行索引或表扫描时，如果遇到一个被另一个事务独占（X）锁定的未提交行，那么DB2将阻塞在行锁上。

互联网摘选

That lock is the row lock that is associated with the row being exported.

该锁是与正在被导出的行相关联的行锁。

互联网摘选

Db2pd reports a lockwait situation for a row lock occurring on table with ID6 in tablespace with ID2.

db2pd报告ID为2的表空间中一个ID为6的表上有一个行锁存在锁等待情形。

互联网摘选

Discussing UPDATE and Row-Level Lock of Multi-Tables in the ORACLE Cursor

ORACLE游标中的多表UPDATE行锁讨论

互联网摘选

The only alternative to a lock on every new row is a table lock ( since there are no page locks in DB2).

对于每个新行之上的锁，惟一可以替代的是表锁（DB2中没有页锁）。

互联网摘选